/*
 Navicat Premium Data Transfer

 Source Server         : lzl的139.196.162.141
 Source Server Type    : MySQL
 Source Server Version : 50733
 Source Host           : 139.196.162.141:3306
 Source Schema         : collectwool

 Target Server Type    : MySQL
 Target Server Version : 50733
 File Encoding         : 65001

 Date: 12/05/2022 10:44:31
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ****************************下列为QRTZ定时任务表，linux需注意区分表名大小写(Windows不需要区分)****************************

-- ----------------------------
-- Table structure for QRTZ_BLOB_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`;
CREATE TABLE `QRTZ_BLOB_TRIGGERS` (
  `sched_name` varchar(120) NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) NOT NULL COMMENT 'QRTZ_TRIGGERS表trigger_name的外键',
  `trigger_group` varchar(200) NOT NULL COMMENT 'QRTZ_TRIGGERS表trigger_group的外键',
  `blob_data` blob COMMENT '存放持久化Trigger对象',
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`),
  CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `QRTZ_TRIGGERS` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Blob类型的触发器表';

-- ----------------------------
-- Records of QRTZ_BLOB_TRIGGERS
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_CALENDARS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CALENDARS`;
CREATE TABLE `QRTZ_CALENDARS` (
  `sched_name` varchar(120) NOT NULL COMMENT '调度名称',
  `calendar_name` varchar(200) NOT NULL COMMENT '日历名称',
  `calendar` blob NOT NULL COMMENT '存放持久化calendar对象',
  PRIMARY KEY (`sched_name`,`calendar_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='日历信息表';

-- ----------------------------
-- Records of QRTZ_CALENDARS
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_CRON_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`;
CREATE TABLE `QRTZ_CRON_TRIGGERS` (
  `sched_name` varchar(120) NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) NOT NULL COMMENT 'QRTZ_TRIGGERS表trigger_name的外键',
  `trigger_group` varchar(200) NOT NULL COMMENT 'QRTZ_TRIGGERS表trigger_group的外键',
  `cron_expression` varchar(200) NOT NULL COMMENT 'cron表达式',
  `time_zone_id` varchar(80) DEFAULT NULL COMMENT '时区',
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`),
  CONSTRAINT `QRTZ_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `QRTZ_TRIGGERS` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cron类型的触发器表';

-- ----------------------------
-- Records of QRTZ_CRON_TRIGGERS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', '0/10 * * * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME106', 'DEFAULT', '0 0 3 * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME107', 'DEFAULT', '0 0 3 * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME108', 'DEFAULT', '0 0/1 * * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME109', 'DEFAULT', '0 0 7 * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME110', 'DEFAULT', '0 0 5 * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', '0/15 * * * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', '0/20 * * * * ?', 'Asia/Shanghai');
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_FIRED_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`;
CREATE TABLE `QRTZ_FIRED_TRIGGERS` (
  `sched_name` varchar(120) NOT NULL COMMENT '调度名称',
  `entry_id` varchar(95) NOT NULL COMMENT '调度器实例id',
  `trigger_name` varchar(200) NOT NULL COMMENT 'QRTZ_TRIGGERS表trigger_name的外键',
  `trigger_group` varchar(200) NOT NULL COMMENT 'QRTZ_TRIGGERS表trigger_group的外键',
  `instance_name` varchar(200) NOT NULL COMMENT '调度器实例名',
  `fired_time` bigint(13) NOT NULL COMMENT '触发的时间',
  `sched_time` bigint(13) NOT NULL COMMENT '定时器制定的时间',
  `priority` int(11) NOT NULL COMMENT '优先级',
  `state` varchar(16) NOT NULL COMMENT '状态',
  `job_name` varchar(200) DEFAULT NULL COMMENT '任务名称',
  `job_group` varchar(200) DEFAULT NULL COMMENT '任务组名',
  `is_nonconcurrent` varchar(1) DEFAULT NULL COMMENT '是否并发',
  `requests_recovery` varchar(1) DEFAULT NULL COMMENT '是否接受恢复执行',
  PRIMARY KEY (`sched_name`,`entry_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='已触发的触发器表';

-- ----------------------------
-- Records of QRTZ_FIRED_TRIGGERS
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_JOB_DETAILS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;
CREATE TABLE `QRTZ_JOB_DETAILS` (
  `sched_name` varchar(120) NOT NULL COMMENT '调度名称',
  `job_name` varchar(200) NOT NULL COMMENT '任务名称',
  `job_group` varchar(200) NOT NULL COMMENT '任务组名',
  `description` varchar(250) DEFAULT NULL COMMENT '相关介绍',
  `job_class_name` varchar(250) NOT NULL COMMENT '执行任务类名称',
  `is_durable` varchar(1) NOT NULL COMMENT '是否持久化',
  `is_nonconcurrent` varchar(1) NOT NULL COMMENT '是否并发',
  `is_update_data` varchar(1) NOT NULL COMMENT '是否更新数据',
  `requests_recovery` varchar(1) NOT NULL COMMENT '是否接受恢复执行',
  `job_data` blob COMMENT '存放持久化job对象',
  PRIMARY KEY (`sched_name`,`job_name`,`job_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='任务详细信息表';

-- ----------------------------
-- Records of QRTZ_JOB_DETAILS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', NULL, 'com.yinNuo.collectWool.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372002B636F6D2E79696E4E756F2E636F6C6C656374576F6F6C2E71756172747A2E656E746974792E5379734A6F6200000000000000010200154C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C000668656164657271007E00094C000269647400104C6A6176612F6C616E672F4C6F6E673B4C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F62496471007E000B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C0006706172616D7371007E00034C000672656D61726B71007E00094C000C72657175657374706172616D71007E00094C000B72657175657374747970657400134C6A6176612F6C616E672F496E74656765723B4C000B73656172636856616C756571007E00094C000673746174757371007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000A4C000375726C71007E00094C000875726C706172616D71007E000978707400013174000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000017E3728AE407874000E302F3130202A202A202A202A203F707074001172795461736B2E72794E6F506172616D7374000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000001740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E697A0E58F82EFBC89740001337074000070707074000131707070707800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME106', 'DEFAULT', NULL, 'com.yinNuo.collectWool.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372002B636F6D2E79696E4E756F2E636F6C6C656374576F6F6C2E71756172747A2E656E746974792E5379734A6F6200000000000000010200154C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C000668656164657271007E00094C000269647400104C6A6176612F6C616E672F4C6F6E673B4C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F62496471007E000B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C0006706172616D7371007E00034C000672656D61726B71007E00094C000C72657175657374706172616D71007E00094C000B72657175657374747970657400134C6A6176612F6C616E672F496E74656765723B4C000B73656172636856616C756571007E00094C000673746174757371007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000A4C000375726C71007E00094C000875726C706172616D71007E0009787074000131740001317372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000017E60BEA1887874000B3020302033202A202A203F7070740027636F6C6C656374776F6F6C5363686564756C65642E7461736B5363686564756C6564282732272974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000006A740012E5A4A9E5A4A9E58585E794B5E7ADBEE588B0740001317074000070707074000130707070707800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME107', 'DEFAULT', NULL, 'com.yinNuo.collectWool.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372002B636F6D2E79696E4E756F2E636F6C6C656374576F6F6C2E71756172747A2E656E746974792E5379734A6F6200000000000000010200154C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C000668656164657271007E00094C000269647400104C6A6176612F6C616E672F4C6F6E673B4C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F62496471007E000B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C0006706172616D7371007E00034C000672656D61726B71007E00094C000C72657175657374706172616D71007E00094C000B72657175657374747970657400134C6A6176612F6C616E672F496E74656765723B4C000B73656172636856616C756571007E00094C000673746174757371007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000A4C000375726C71007E00094C000875726C706172616D71007E0009787074000131740001317372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000017FE4BF42707874000B3020302033202A202A203F7070740027636F6C6C656374776F6F6C5363686564756C65642E7461736B5363686564756C6564282733272974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000006B74000F776471E5A4A9E5A4A9E7ADBEE588B0740001317074000070707074000131707070707800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME108', 'DEFAULT', NULL, 'com.yinNuo.collectWool.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372002B636F6D2E79696E4E756F2E636F6C6C656374576F6F6C2E71756172747A2E656E746974792E5379734A6F6200000000000000010200154C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C000668656164657271007E00094C000269647400104C6A6176612F6C616E672F4C6F6E673B4C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F62496471007E000B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C0006706172616D7371007E00034C000672656D61726B71007E00094C000C72657175657374706172616D71007E00094C000B72657175657374747970657400134C6A6176612F6C616E672F496E74656765723B4C000B73656172636856616C756571007E00094C000673746174757371007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000A4C000375726C71007E00094C000875726C706172616D71007E0009787074000131740001317372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018063B8DC087874000D3020302F31202A202A202A203F7070740027636F6C6C656374776F6F6C5363686564756C65642E7461736B5363686564756C6564282734272974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000006C74000CE8BDACE8BDACE7ADBEE588B0740001317074000070707074000130707070707800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME109', 'DEFAULT', NULL, 'com.yinNuo.collectWool.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372002B636F6D2E79696E4E756F2E636F6C6C656374576F6F6C2E71756172747A2E656E746974792E5379734A6F6200000000000000010200154C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C000668656164657271007E00094C000269647400104C6A6176612F6C616E672F4C6F6E673B4C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F62496471007E000B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C0006706172616D7371007E00034C000672656D61726B71007E00094C000C72657175657374706172616D71007E00094C000B72657175657374747970657400134C6A6176612F6C616E672F496E74656765723B4C000B73656172636856616C756571007E00094C000673746174757371007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000A4C000375726C71007E00094C000875726C706172616D71007E0009787074000131740001317372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018063BABC807874000B3020302037202A202A203F7070740027636F6C6C656374776F6F6C5363686564756C65642E7461736B5363686564756C6564282735272974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000006D740012E8BDACE8BDACE6B58FE8A788E59586E59381740001317074000070707074000130707070707800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME110', 'DEFAULT', NULL, 'com.yinNuo.collectWool.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372002B636F6D2E79696E4E756F2E636F6C6C656374576F6F6C2E71756172747A2E656E746974792E5379734A6F6200000000000000010200154C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C000668656164657271007E00094C000269647400104C6A6176612F6C616E672F4C6F6E673B4C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F62496471007E000B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C0006706172616D7371007E00034C000672656D61726B71007E00094C000C72657175657374706172616D71007E00094C000B72657175657374747970657400134C6A6176612F6C616E672F496E74656765723B4C000B73656172636856616C756571007E00094C000673746174757371007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000A4C000375726C71007E00094C000875726C706172616D71007E0009787074000131740001317372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018063BBF8E87874000B3020302035202A202A203F7070740027636F6C6C656374776F6F6C5363686564756C65642E7461736B5363686564756C6564282736272974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000006E74000FE8BDACE8BDACE79C8BE8A786E9A291740001317074000070707074000130707070707800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', NULL, 'com.yinNuo.collectWool.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372002B636F6D2E79696E4E756F2E636F6C6C656374576F6F6C2E71756172747A2E656E746974792E5379734A6F6200000000000000010200154C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C000668656164657271007E00094C000269647400104C6A6176612F6C616E672F4C6F6E673B4C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F62496471007E000B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C0006706172616D7371007E00034C000672656D61726B71007E00094C000C72657175657374706172616D71007E00094C000B72657175657374747970657400134C6A6176612F6C616E672F496E74656765723B4C000B73656172636856616C756571007E00094C000673746174757371007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000A4C000375726C71007E00094C000875726C706172616D71007E000978707400013174000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000017E3728AE407874000E302F3135202A202A202A202A203F707074001572795461736B2E7279506172616D7328277279272974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000002740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E69C89E58F82EFBC89740001337074000070707074000131707070707800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', NULL, 'com.yinNuo.collectWool.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372002B636F6D2E79696E4E756F2E636F6C6C656374576F6F6C2E71756172747A2E656E746974792E5379734A6F6200000000000000010200154C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C000668656164657271007E00094C000269647400104C6A6176612F6C616E672F4C6F6E673B4C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F62496471007E000B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C0006706172616D7371007E00034C000672656D61726B71007E00094C000C72657175657374706172616D71007E00094C000B72657175657374747970657400134C6A6176612F6C616E672F496E74656765723B4C000B73656172636856616C756571007E00094C000673746174757371007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000A4C000375726C71007E00094C000875726C706172616D71007E000978707400013174000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000017E3728AE407874000E302F3230202A202A202A202A203F707074003872795461736B2E72794D756C7469706C65506172616D7328277279272C20747275652C20323030304C2C203331362E3530442C203130302974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000003740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E5A49AE58F82EFBC89740001337074000070707074000131707070707800);
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_LOCKS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_LOCKS`;
CREATE TABLE `QRTZ_LOCKS` (
  `sched_name` varchar(120) NOT NULL COMMENT '调度名称',
  `lock_name` varchar(40) NOT NULL COMMENT '悲观锁名称',
  PRIMARY KEY (`sched_name`,`lock_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='存储的悲观锁信息表';

-- ----------------------------
-- Records of QRTZ_LOCKS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_LOCKS` VALUES ('CollectWoolScheduler', 'STATE_ACCESS');
INSERT INTO `QRTZ_LOCKS` VALUES ('CollectWoolScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_PAUSED_TRIGGER_GRPS`;
CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` (
  `sched_name` varchar(120) NOT NULL COMMENT '调度名称',
  `trigger_group` varchar(200) NOT NULL COMMENT 'QRTZ_TRIGGERS表trigger_group的外键',
  PRIMARY KEY (`sched_name`,`trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='暂停的触发器表';

-- ----------------------------
-- Records of QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_SCHEDULER_STATE
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`;
CREATE TABLE `QRTZ_SCHEDULER_STATE` (
  `sched_name` varchar(120) NOT NULL COMMENT '调度名称',
  `instance_name` varchar(200) NOT NULL COMMENT '实例名称',
  `last_checkin_time` bigint(13) NOT NULL COMMENT '上次检查时间',
  `checkin_interval` bigint(13) NOT NULL COMMENT '检查间隔时间',
  PRIMARY KEY (`sched_name`,`instance_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='调度器状态表';

-- ----------------------------
-- Records of QRTZ_SCHEDULER_STATE
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_SCHEDULER_STATE` VALUES ('CollectWoolScheduler', 'lzl1650963219080', 1652323461832, 15000);
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` (
  `sched_name` varchar(120) NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) NOT NULL COMMENT 'QRTZ_TRIGGERS表trigger_name的外键',
  `trigger_group` varchar(200) NOT NULL COMMENT 'QRTZ_TRIGGERS表trigger_group的外键',
  `repeat_count` bigint(7) NOT NULL COMMENT '重复的次数统计',
  `repeat_interval` bigint(12) NOT NULL COMMENT '重复的间隔时间',
  `times_triggered` bigint(10) NOT NULL COMMENT '已经触发的次数',
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`),
  CONSTRAINT `QRTZ_SIMPLE_TRIGGERS_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `QRTZ_TRIGGERS` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='简单触发器的信息表';

-- ----------------------------
-- Records of QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPROP_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPROP_TRIGGERS` (
  `sched_name` varchar(120) NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) NOT NULL COMMENT 'QRTZ_TRIGGERS表trigger_name的外键',
  `trigger_group` varchar(200) NOT NULL COMMENT 'QRTZ_TRIGGERS表trigger_group的外键',
  `str_prop_1` varchar(512) DEFAULT NULL COMMENT 'String类型的trigger的第一个参数',
  `str_prop_2` varchar(512) DEFAULT NULL COMMENT 'String类型的trigger的第二个参数',
  `str_prop_3` varchar(512) DEFAULT NULL COMMENT 'String类型的trigger的第三个参数',
  `int_prop_1` int(11) DEFAULT NULL COMMENT 'int类型的trigger的第一个参数',
  `int_prop_2` int(11) DEFAULT NULL COMMENT 'int类型的trigger的第二个参数',
  `long_prop_1` bigint(20) DEFAULT NULL COMMENT 'long类型的trigger的第一个参数',
  `long_prop_2` bigint(20) DEFAULT NULL COMMENT 'long类型的trigger的第二个参数',
  `dec_prop_1` decimal(13,4) DEFAULT NULL COMMENT 'decimal类型的trigger的第一个参数',
  `dec_prop_2` decimal(13,4) DEFAULT NULL COMMENT 'decimal类型的trigger的第二个参数',
  `bool_prop_1` varchar(1) DEFAULT NULL COMMENT 'Boolean类型的trigger的第一个参数',
  `bool_prop_2` varchar(1) DEFAULT NULL COMMENT 'Boolean类型的trigger的第二个参数',
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`),
  CONSTRAINT `QRTZ_SIMPROP_TRIGGERS_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `QRTZ_TRIGGERS` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='同步机制的行锁表';

-- ----------------------------
-- Records of QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_TRIGGERS`;
CREATE TABLE `QRTZ_TRIGGERS` (
  `sched_name` varchar(120) NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) NOT NULL COMMENT '触发器的名字',
  `trigger_group` varchar(200) NOT NULL COMMENT '触发器所属组的名字',
  `job_name` varchar(200) NOT NULL COMMENT 'QRTZ_JOB_DETAILS表job_name的外键',
  `job_group` varchar(200) NOT NULL COMMENT 'QRTZ_JOB_DETAILS表job_group的外键',
  `description` varchar(250) DEFAULT NULL COMMENT '相关介绍',
  `next_fire_time` bigint(13) DEFAULT NULL COMMENT '上一次触发时间（毫秒）',
  `prev_fire_time` bigint(13) DEFAULT NULL COMMENT '下一次触发时间（默认为-1表示不触发）',
  `priority` int(11) DEFAULT NULL COMMENT '优先级',
  `trigger_state` varchar(16) NOT NULL COMMENT '触发器状态',
  `trigger_type` varchar(8) NOT NULL COMMENT '触发器的类型',
  `start_time` bigint(13) NOT NULL COMMENT '开始时间',
  `end_time` bigint(13) DEFAULT NULL COMMENT '结束时间',
  `calendar_name` varchar(200) DEFAULT NULL COMMENT '日程表名称',
  `misfire_instr` smallint(2) DEFAULT NULL COMMENT '补偿执行的策略',
  `job_data` blob COMMENT '存放持久化job对象',
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`),
  KEY `sched_name` (`sched_name`,`job_name`,`job_group`),
  CONSTRAINT `QRTZ_TRIGGERS_ibfk_1` FOREIGN KEY (`sched_name`, `job_name`, `job_group`) REFERENCES `QRTZ_JOB_DETAILS` (`sched_name`, `job_name`, `job_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='触发器详细信息表';

-- ----------------------------
-- Records of QRTZ_TRIGGERS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_TRIGGERS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', 'TASK_CLASS_NAME1', 'DEFAULT', NULL, 1650964340000, -1, 5, 'PAUSED', 'CRON', 1650964340000, 0, NULL, 2, '');
INSERT INTO `QRTZ_TRIGGERS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME106', 'DEFAULT', 'TASK_CLASS_NAME106', 'DEFAULT', NULL, 1652382000000, 1652295600000, 5, 'WAITING', 'CRON', 1650964343000, 0, NULL, -1, '');
INSERT INTO `QRTZ_TRIGGERS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME107', 'DEFAULT', 'TASK_CLASS_NAME107', 'DEFAULT', NULL, 1650999600000, -1, 5, 'PAUSED', 'CRON', 1650964344000, 0, NULL, -1, '');
INSERT INTO `QRTZ_TRIGGERS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME108', 'DEFAULT', 'TASK_CLASS_NAME108', 'DEFAULT', NULL, 1652323500000, 1652323440000, 5, 'WAITING', 'CRON', 1650964345000, 0, NULL, -1, '');
INSERT INTO `QRTZ_TRIGGERS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME109', 'DEFAULT', 'TASK_CLASS_NAME109', 'DEFAULT', NULL, 1652396400000, 1652310000000, 5, 'WAITING', 'CRON', 1650964346000, 0, NULL, -1, '');
INSERT INTO `QRTZ_TRIGGERS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME110', 'DEFAULT', 'TASK_CLASS_NAME110', 'DEFAULT', NULL, 1652389200000, 1652302800000, 5, 'WAITING', 'CRON', 1650964347000, 0, NULL, -1, '');
INSERT INTO `QRTZ_TRIGGERS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', 'TASK_CLASS_NAME2', 'DEFAULT', NULL, 1650964350000, -1, 5, 'PAUSED', 'CRON', 1650964341000, 0, NULL, 2, '');
INSERT INTO `QRTZ_TRIGGERS` VALUES ('CollectWoolScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', 'TASK_CLASS_NAME3', 'DEFAULT', NULL, 1650964360000, -1, 5, 'PAUSED', 'CRON', 1650964342000, 0, NULL, 2, '');
COMMIT;

-- ****************************下列为项目表****************************

-- ----------------------------
-- Table structure for custom_job
-- ----------------------------
DROP TABLE IF EXISTS `custom_job`;
CREATE TABLE `custom_job` (
                              `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键（不可重复且关联定时任务里的参数）',
                              `jobName` varchar(255) DEFAULT NULL COMMENT '任务名称（关联定时任务里的任务名称）',
                              `requesttype` int(2) DEFAULT NULL COMMENT '请求方式（0-get 1-post 2-put 3-delete）',
                              `url` varchar(255) DEFAULT NULL COMMENT '请求的url',
                              `urlparam` varchar(5000) DEFAULT NULL COMMENT 'url中携带的参数',
                              `header` varchar(5000) DEFAULT NULL COMMENT '请求头内容',
                              `requestparam` varchar(5000) DEFAULT NULL COMMENT '表单提交携带的参数内容',
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='自定义定时任务执行请求表';

-- ----------------------------
-- Records of custom_job
-- ----------------------------
BEGIN;
INSERT INTO `custom_job` VALUES (1, 'zjrw', 0, 'www.baidu.com', '=2', 'b=2', 'c=2');
INSERT INTO `custom_job` VALUES (2, '天天充电签到', 1, 'https://api.cd1a.cn/index.php/index28/Activity/sign', '', 'Accept=*/*&Accept-Encoding=gzip,deflate,br&Accept-Language=zh-Hans-CN;q=1&Connection=keep-alive&Content-Length=80&Content-Type=application/x-www-form-urlencoded&Host=api.cd1a.cn&User-Agent=Charge/3.2.3 (iPhone; iOS 14.2.1; Scale/3.00)', 'integral=10&platform=ios&userid_locked=b1c3Z0RtOWpBa0hiT3lSYVg%3D&version=3.2.3');
INSERT INTO `custom_job` VALUES (3, 'wdq天天签到', 1, 'https://api.cd1a.cn/index.php/index28/Activity/sign', '', 'Accept=*/*&Accept-Encoding=gzip,deflate,br&Accept-Language=zh-Hans-CN;q&Connection=keep-alive&Content-Length=80&Content-Type=application/x-www-form-urlencoded&Host=api.cd1a.cn&User-Agent=Charge/3.2.3 (iPhone; iOS 14.2.1; Scale/3.00)', 'integral=5&platform=ios&userid_locked=emphNU94ckdMQ2NuNnlXa24%253D&version=3.2.3');
INSERT INTO `custom_job` VALUES (4, '转转签到', 1, 'https://app.zhuanzhuan.com/zzopen/bizinfoshow/makeMoneyAward', '', 'Accept=application/json, text/plain, */*&Accept-Encoding=gzip, deflate, br&Accept-Language=zh-CN,zh-Hans;q=0.9&Connection=keep-alive&Content-Length=42&Content-Type=application/json&Cookie=zzVisitStack=[{\"type\":\"load\",\"href\":\"https://m.zhuanzhuan.com/biz/bizembrave/index.html?__zpm=1%5EP1006%5E14%5E7%5E%E5%A4%A9%E5%A4%A9%E8%B5%9A%E9%92%B1%7C2%5ED1043%5E101%5E0%5E0&zzv=9.8.0&tt=12E6EFCC938AD281ED243C800726A9BA#/earn/withdraw\",\"time\":1650930484358},{\"type\":\"zz-showDocument\",\"href\":\"https://m.zhuanzhuan.com/biz/bizembrave/index.html?__zpm=1%5EP1006%5E14%5E7%5E%E5%A4%A9%E5%A4%A9%E8%B5%9A%E9%92%B1&zzv=9.8.0&tt=6980FACC0F20C5AB73581D18D354905D#/browseAndEarn/home\",\"time\":1650930596871}]; expires=1651016952255; from=2^D1043^101^0^0; referrerObj={\"refpagetype\":\"D1043\",\"refpagequery\":\"\",\"refsubpageID\":\"\",\"refsectionId\":\"\",\"refsortId\":\"\"}; zpm=1^P1006^14^7^天天赚钱; PPU=\"TT=8b75825655a3f151b783706f986be60509fde117&UID=11214649081004800&CT=1650930459363&SF=ZHUANZHUAN&SCT=1650934059363&V=2&ET=1653522459363&AP=16\"; app-apn=WIFI; app-clientip=2408:8444:d02:11d8:1cde:7033:5c0:c597; app-os=iOS; app-resolution=1284x2778; brand=Apple; continent_ab=2; h5tc_channel=h5tc_zzapp; lat=31.81698148865986; lon=117.20585874910671; model=iPhone13,4; t=16; tk=1bed49fce4013cc33f50762c77b8923ffc3b3e6f; uid=11214649081004800; v=9.8.0; zz_t=16; id58=c5/nR2JnMr/DHFp8DihTAg==; idzz=c5/nR2JjighjKo2pNb6YAg==&Csrf-Token=8b75825655a3f151b783706f986be60509fde117&Host=app.zhuanzhuan.com&Origin=https://m.zhuanzhuan.com&Referer=https://m.zhuanzhuan.com/&User-Agent=Mozilla/5.0 (iPhone; CPU iPhone OS 15_4 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 zzVersion/9.8.0 zzT/16 zzDevice/1_141.0_3.0 zzApp/58ZhuanZhuan', '{  \"type\": 4,  \"awardContext\": {    \"awardLimit\": 1  }}');
INSERT INTO `custom_job` VALUES (5, '转转浏览商品', 1, 'https://app.zhuanzhuan.com/zzopen/bizinfoshow/makeMoneyAward', '', 'Accept=application/json, text/plain, */*&Accept-Encoding=gzip, deflate, br&Accept-Language=zh-CN,zh-Hans;q=0.9&Connection=keep-alive&Content-Length=88&Content-Type=application/json&Cookie=PPU=\"TT=8b75825655a3f151b783706f986be60509fde117&UID=11214649081004800&CT=1650930459363&SF=ZHUANZHUAN&SCT=1650934059363&V=2&ET=1653522459363&AP=16\"; zzVisitStack=[{\"type\":\"load\",\"href\":\"https://m.zhuanzhuan.com/biz/bizembrave/index.html?__zpm=1%5EP1006%5E14%5E7%5E%E5%A4%A9%E5%A4%A9%E8%B5%9A%E9%92%B1%7C2%5ED1043%5E101%5E0%5E0&zzv=9.8.0&tt=12E6EFCC938AD281ED243C800726A9BA#/earn/withdraw\",\"time\":1650930484358},{\"type\":\"zz-showDocument\",\"href\":\"https://m.zhuanzhuan.com/biz/bizembrave/index.html?__zpm=1%5EP1006%5E14%5E7%5E%E5%A4%A9%E5%A4%A9%E8%B5%9A%E9%92%B1&zzv=9.8.0&tt=6980FACC0F20C5AB73581D18D354905D#/browseAndEarn/home\",\"time\":1650930789559}]; expires=1651017186322; zpm=1^P1006^14^7^天天赚钱|2^D1043^103^100^0; from=1^P1006^14^7^天天赚钱; referrerObj={\"refpagetype\":\"D1043\",\"refpagequery\":\"\",\"refsubpageID\":\"\",\"refsectionId\":\"\",\"refsortId\":\"\"}; app-apn=WIFI; app-clientip=2408:8444:d02:11d8:1cde:7033:5c0:c597; app-os=iOS; app-resolution=1284x2778; brand=Apple; continent_ab=2; h5tc_channel=h5tc_zzapp; lat=31.81698148865986; lon=117.20585874910671; model=iPhone13,4; t=16; tk=1bed49fce4013cc33f50762c77b8923ffc3b3e6f; uid=11214649081004800; v=9.8.0; zz_t=16; id58=c5/nR2JnMr/DHFp8DihTAg==; idzz=c5/nR2JjighjKo2pNb6YAg==&Csrf-Token=8b75825655a3f151b783706f986be60509fde117&Host=app.zhuanzhuan.com&Origin=https://m.zhuanzhuan.com&Referer=https://m.zhuanzhuan.com/&User-Agent=Mozilla/5.0 (iPhone; CPU iPhone OS 15_4 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 zzVersion/9.8.0 zzT/16 zzDevice/1_141.0_3.0 zzApp/58ZhuanZhuan', '{  \"type\": 2,  \"awardContext\": {    \"target\": \"c2b78dfb-f02d-4e50-a453-6aa5dbd042ac\",    \"infoType\": 1  }}');
INSERT INTO `custom_job` VALUES (6, '转转看视频', 1, 'https://app.zhuanzhuan.com/zzopen/bizinfoshow/makeMoneyAward', '', 'Accept=application/json, text/plain, */*&Accept-Encoding=gzip, deflate, br&Accept-Language=zh-CN,zh-Hans;q=0.9&Connection=keep-alive&Content-Length=28&Content-Type=application/json&Cookie=zzVisitStack=[{\"type\":\"load\",\"href\":\"https://m.zhuanzhuan.com/biz/bizembrave/index.html?__zpm=1%5EP1006%5E14%5E7%5E%E5%A4%A9%E5%A4%A9%E8%B5%9A%E9%92%B1%7C2%5ED1043%5E101%5E0%5E0&zzv=9.8.0&tt=71AB94267BD4A0CDC0AB5D58DDE81080#/earn/withdraw\",\"time\":1650931055594},{\"type\":\"zz-showDocument\",\"href\":\"https://m.zhuanzhuan.com/biz/bizembrave/index.html?__zpm=1%5EP1006%5E14%5E7%5E%E5%A4%A9%E5%A4%A9%E8%B5%9A%E9%92%B1&zzv=9.8.0&tt=6980FACC0F20C5AB73581D18D354905D#/browseAndEarn/home\",\"time\":1650931183776}]; PPU=\"TT=8b75825655a3f151b783706f986be60509fde117&UID=11214649081004800&CT=1650930459363&SF=ZHUANZHUAN&SCT=1650934059363&V=2&ET=1653522459363&AP=16\"; expires=1651017542965; from=2^D1043^101^0^0; referrerObj={\"refpagetype\":\"D1043\",\"refpagequery\":\"\",\"refsubpageID\":\"\",\"refsectionId\":\"\",\"refsortId\":\"\"}; zpm=1^P1006^14^7^天天赚钱; app-apn=WIFI; app-clientip=2408:8444:d02:11d8:1cde:7033:5c0:c597; app-os=iOS; app-resolution=1284x2778; brand=Apple; continent_ab=2; h5tc_channel=h5tc_zzapp; lat=31.81698148865986; lon=117.20585874910671; model=iPhone13,4; t=16; tk=1bed49fce4013cc33f50762c77b8923ffc3b3e6f; uid=11214649081004800; v=9.8.0; zz_t=16; id58=c5/nR2JnMr/DHFp8DihTAg==; idzz=c5/nR2JjighjKo2pNb6YAg==&Csrf-Token=8b75825655a3f151b783706f986be60509fde117&Host=app.zhuanzhuan.com&Origin=https://m.zhuanzhuan.com&Referer=https://m.zhuanzhuan.com/ &User-Agent=Mozilla/5.0 (iPhone; CPU iPhone OS 15_4 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 zzVersion/9.8.0 zzT/16 zzDevice/1_141.0_3.0 zzApp/58ZhuanZhuan', '{  \"type\": 4,  \"awardContext\": {}}');
COMMIT;

-- ----------------------------
-- Table structure for login_operation_log
-- ----------------------------
DROP TABLE IF EXISTS `login_operation_log`;
CREATE TABLE `login_operation_log` (
                                       `id` int(11) NOT NULL COMMENT '主键id',
                                       `user_id` int(11) DEFAULT NULL COMMENT '登录id',
                                       `login_time` datetime DEFAULT NULL COMMENT '登录时间',
                                       `loginout_time` datetime DEFAULT NULL COMMENT '退出时间',
                                       `operation` varchar(255) DEFAULT NULL COMMENT '操作日志',
                                       PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='登录操作日志表';

-- ----------------------------
-- Records of login_operation_log
-- ----------------------------
BEGIN;
COMMIT;


-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务ID',
  `job_name` varchar(64) NOT NULL DEFAULT '' COMMENT '任务名称',
  `job_group` varchar(64) NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名',
  `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串',
  `cron_expression` varchar(255) DEFAULT '' COMMENT 'cron执行表达式',
  `misfire_policy` varchar(20) DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）',
  `concurrent` char(1) DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1暂停）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT '' COMMENT '备注信息',
  PRIMARY KEY (`job_id`,`job_name`,`job_group`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8 COMMENT='定时任务调度表';

-- ----------------------------
-- Records of sys_job
-- ----------------------------
BEGIN;
INSERT INTO `sys_job` VALUES (1, '系统默认（无参）', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', '2022-01-08 08:48:40', '', NULL, '');
INSERT INTO `sys_job` VALUES (2, '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(\'ry\')', '0/15 * * * * ?', '3', '1', '1', 'admin', '2022-01-08 08:48:40', '', NULL, '');
INSERT INTO `sys_job` VALUES (3, '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', '2022-01-08 08:48:40', '', NULL, '');
INSERT INTO `sys_job` VALUES (106, '天天充电签到', 'DEFAULT', 'collectwoolScheduled.taskScheduled(\'2\')', '0 0 3 * * ?', '1', '1', '0', '1', '2022-01-16 10:36:53', '1', '2022-04-15 10:25:09', '');
INSERT INTO `sys_job` VALUES (107, 'wdq天天签到', 'DEFAULT', 'collectwoolScheduled.taskScheduled(\'3\')', '0 0 3 * * ?', '1', '1', '1', '1', '2022-04-01 18:50:14', '1', '2022-04-26 08:52:21', '');
INSERT INTO `sys_job` VALUES (108, '转转签到', 'DEFAULT', 'collectwoolScheduled.taskScheduled(\'4\')', '0 0/1 * * * ?', '1', '1', '0', '1', '2022-04-26 10:35:01', '1', '2022-04-26 17:09:52', '');
INSERT INTO `sys_job` VALUES (109, '转转浏览商品', 'DEFAULT', 'collectwoolScheduled.taskScheduled(\'5\')', '0 0 7 * * ?', '1', '1', '0', '1', '2022-04-26 10:37:04', '1', '2022-04-26 17:04:17', '');
INSERT INTO `sys_job` VALUES (110, '转转看视频', 'DEFAULT', 'collectwoolScheduled.taskScheduled(\'6\')', '0 0 5 * * ?', '1', '1', '0', '1', '2022-04-26 10:38:25', '1', '2022-04-26 17:09:30', '');
COMMIT;

-- ----------------------------
-- Table structure for sys_job_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_job_log`;
CREATE TABLE `sys_job_log` (
  `job_log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志ID',
  `job_name` varchar(64) NOT NULL COMMENT '任务名称',
  `job_group` varchar(64) NOT NULL COMMENT '任务组名',
  `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串',
  `job_message` varchar(500) DEFAULT NULL COMMENT '日志信息',
  `status` char(1) DEFAULT '0' COMMENT '执行状态（0正常 1失败）',
  `exception_info` varchar(2000) DEFAULT '' COMMENT '异常信息',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`job_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='定时任务调度日志表';

-- ----------------------------
-- Records of sys_job_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_name` varchar(50) DEFAULT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '登录密码',
  `sex` int(2) DEFAULT NULL COMMENT '性别 0-女 1-男 2-保密',
  `phone` varchar(20) DEFAULT NULL COMMENT '手机号码',
  `create_time` datetime DEFAULT NULL COMMENT '账号创建时间',
  `is_del` int(2) DEFAULT NULL COMMENT '是否删除 0-未删除 1-已删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='系统登录用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 'admin', '123456', 0, '13059455633', '2021-12-08 13:15:46', 0);
INSERT INTO `sys_user` VALUES (5, 'aaa', '111111', 0, '13059455677', '2021-12-08 13:15:46', 0);
INSERT INTO `sys_user` VALUES (16, 'test12345', 'qwert12345', 2, '13053055944', '2021-12-08 08:49:05', 0);
INSERT INTO `sys_user` VALUES (17, 'qwerty', '111111', 2, '13059455672', '2021-12-18 10:58:41', 0);
INSERT INTO `sys_user` VALUES (18, '161', '666666', 2, '14790289092', '2022-04-15 15:30:05', 0);
COMMIT;

-- ----------------------------
-- Table structure for user_do_task
-- ----------------------------
DROP TABLE IF EXISTS `user_do_task`;
CREATE TABLE `user_do_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id（关联user_task的id）',
  `wool_task_id` int(11) DEFAULT NULL COMMENT '做羊毛的appid (关联wool_task的id)',
  `wool_task_detail_id` int(11) DEFAULT NULL COMMENT '做app下的具体任务的id(关联wool_task_detail的id)',
  `token` varchar(2000) DEFAULT NULL COMMENT '任务对应的token',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COMMENT='用户做任务详细表 所有数据都是从这里判断';

-- ----------------------------
-- Records of user_do_task
-- ----------------------------
BEGIN;
INSERT INTO `user_do_task` VALUES (1, 6, 1, 1, 'GicEF3I0ZOzkwznfFOqLWTYHc9BqbaER');
INSERT INTO `user_do_task` VALUES (2, 6, 1, 2, 'GicEF3I0ZOzkwznfFOqLWTYHc9BqbaER');
INSERT INTO `user_do_task` VALUES (3, 6, 1, 3, 'GicEF3I0ZOzkwznfFOqLWTYHc9BqbaER');
INSERT INTO `user_do_task` VALUES (4, 6, 1, 4, 'GicEF3I0ZOzkwznfFOqLWTYHc9BqbaER');
INSERT INTO `user_do_task` VALUES (5, 6, 1, 5, 'GicEF3I0ZOzkwznfFOqLWTYHc9BqbaER');
INSERT INTO `user_do_task` VALUES (6, 6, 1, 6, 'GicEF3I0ZOzkwznfFOqLWTYHc9BqbaER');
INSERT INTO `user_do_task` VALUES (7, 6, 1, 7, 'GicEF3I0ZOzkwznfFOqLWTYHc9BqbaER');
INSERT INTO `user_do_task` VALUES (8, 6, 1, 8, 'GicEF3I0ZOzkwznfFOqLWTYHc9BqbaER');
INSERT INTO `user_do_task` VALUES (9, 6, 1, 9, 'GicEF3I0ZOzkwznfFOqLWTYHc9BqbaER');
INSERT INTO `user_do_task` VALUES (10, 6, 1, 10, 'GicEF3I0ZOzkwznfFOqLWTYHc9BqbaER');
INSERT INTO `user_do_task` VALUES (11, 6, 2, 1, '9NwGV8Ov71o=gW5NEpb6rjb84bkaCQyOq-myT0C-Ktb_MP7nAiOBLB_wx38tOwRBi83B72KxXlhVtkBsaXSvW25YvfGfDYjWj2yUz7KyHW6O_gKlxnQgFCbo7OdN5e8owTN-BocnYJNSR0TCqq23Hy3DjAOghf9CPw0YYHU4D_9uKNH4m5rZIvKSNgUJQXY_mV4mAwCzbne2P4A1gv3lkYZC7cjTUaGeeQe8eNsNz4WPwoFKCc7PPn1mnEoHMy5xzqBwOaUEVt_AAcg-_n6w5PXEO1WMREisR9RpeTwjXpmbppGizScPu3Zj5csJOJHtUtHumGBip_uiy4BTxvj68p8MqF9Eb353ebpZiRK4N7diW2H_2Ke-0_K989rQ_hEjRJUyX5Oy9KxiZ6FG0BbN1F6EF130Ltv21Ii2VyhWMVcd2TnusF8oIvVRnWc_8roTTYALmCrDMaDXyLG1vwhCAFvjMxLTC_gBKJPv_zsSjh202IjflBHMJWiUrl8aQGvn_eAVuBy9dAAtAFqG1SIPttJrVtVoMFujCkJ0ZVSBW_6cr3QEPLJQ672trcK53D98YLXtTyt30eXMKTU_L3kELJfjWEYQjD99N1fP6imLLXszEbX3ztJQ2zN9n-dKhVZGrSLPUBP2oGc-QiJkh6_kuXW-1dtILiMtFIM-XQ5XD9SsrCI7U99XY1bxTM_wOSv_MmqPqCiafz5e3H8Zl7buW8geZN3OAXXqxLedWrW-UiLlX9RuUgSOn3EIimUYaMpC50N28SPYPr6ekQ43-W4Usfzdvr73v_nRXIaqCLygf8OnIeg1u5GEENg4zwLa51v3wEIhBuEYS08A5icePd75NbN67YAyqqkVLg==');
INSERT INTO `user_do_task` VALUES (12, 6, 2, 11, '9NwGV8Ov71o=gW5NEpb6rjb84bkaCQyOq-myT0C-Ktb_MP7nAiOBLB_wx38tOwRBi83B72KxXlhVtkBsaXSvW25YvfGfDYjWj2yUz7KyHW6O_gKlxnQgFCbo7OdN5e8owTN-BocnYJNSR0TCqq23Hy3DjAOghf9CPw0YYHU4D_9uKNH4m5rZIvKSNgUJQXY_mV4mAwCzbne2P4A1gv3lkYZC7cjTUaGeeQe8eNsNz4WPwoFKCc7PPn1mnEoHMy5xzqBwOaUEVt_AAcg-_n6w5PXEO1WMREisRyjpGXUjuGUQNvME2CoO0z1xV7dchnB9Qm4_yWJCHcfVr5Gkz0ckeuPyxxGK7Y-tjdQGcdCriIi9Yc8Y710ffRcHB1ZWEJx4QtxoJXs-85ve8AWB7M30P0uoh_Sdqbnz6F54-HTSiLZuyWrPdyL4aINjRbp-5Jn1UeXEUPsECtcfMCa7vNszw64EoWpw-wajfhvUIYkow39pC0TcIDZZ1jWV_tMYiO-tL2oAzp53Y3U9sgtKNRlAv9ERM-tBcv5LxhkB6sOT9s5GgoZ4Wny6Fxmo8ODVmgEF5fdHE4Rg5Jc095YPzRiwy3FtUxXjqQOw4nhnT5Z63oKUqQQXtoP5QCTZkSw_L6PH9q09Yq6nOx6_DX_4HaxD_dU-REl-edarKrgkBn9XsvsreJ9s0vJhIRTLuzdGYjZXLdUOi0PKjx7Q7S_2aIf1RGmChL6AM17bB_E-zw5vWkFgTf0w3TxF68fdxU_hL2sJRiJnjz52qkL4cFyC6poOYnK6_eU9op-O6VGnfA9_HF8oP7zKVTq0e25AdBuaXwLp31-RqrNs8nHcErj2tMtMlFfTzt76lrqZkw==');
INSERT INTO `user_do_task` VALUES (13, 1, 1, 1, 'GNmkVAOKG2luS1tEqhCW1c7wJeQdDThO');
INSERT INTO `user_do_task` VALUES (14, 1, 1, 2, 'GNmkVAOKG2luS1tEqhCW1c7wJeQdDThO');
INSERT INTO `user_do_task` VALUES (15, 1, 1, 3, 'GNmkVAOKG2luS1tEqhCW1c7wJeQdDThO');
INSERT INTO `user_do_task` VALUES (16, 1, 1, 4, 'GNmkVAOKG2luS1tEqhCW1c7wJeQdDThO');
INSERT INTO `user_do_task` VALUES (17, 1, 1, 5, 'GNmkVAOKG2luS1tEqhCW1c7wJeQdDThO');
INSERT INTO `user_do_task` VALUES (18, 1, 1, 6, 'GNmkVAOKG2luS1tEqhCW1c7wJeQdDThO');
INSERT INTO `user_do_task` VALUES (19, 1, 1, 7, 'GNmkVAOKG2luS1tEqhCW1c7wJeQdDThO');
INSERT INTO `user_do_task` VALUES (20, 1, 1, 8, 'GNmkVAOKG2luS1tEqhCW1c7wJeQdDThO');
INSERT INTO `user_do_task` VALUES (21, 1, 1, 9, 'GNmkVAOKG2luS1tEqhCW1c7wJeQdDThO');
INSERT INTO `user_do_task` VALUES (22, 1, 1, 10, 'GNmkVAOKG2luS1tEqhCW1c7wJeQdDThO');
COMMIT;

-- ----------------------------
-- Table structure for user_task
-- ----------------------------
DROP TABLE IF EXISTS `user_task`;
CREATE TABLE `user_task` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键用户id(做羊毛任务的用户)',
  `user_name` varchar(255) DEFAULT NULL COMMENT '羊毛任务的用户名',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='羊毛用户表';

-- ----------------------------
-- Records of user_task
-- ----------------------------
BEGIN;
INSERT INTO `user_task` VALUES (1, '尹诺');
INSERT INTO `user_task` VALUES (2, '小胖墩');
INSERT INTO `user_task` VALUES (3, '大高个');
INSERT INTO `user_task` VALUES (4, '大大怪');
INSERT INTO `user_task` VALUES (5, '小小怪');
INSERT INTO `user_task` VALUES (6, '张老三');
INSERT INTO `user_task` VALUES (7, '哦豁去洗洗');
COMMIT;

-- ----------------------------
-- Table structure for wool_task
-- ----------------------------
DROP TABLE IF EXISTS `wool_task`;
CREATE TABLE `wool_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `wool_name` varchar(50) DEFAULT NULL COMMENT '羊毛app名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='羊毛表 存是什么羊毛的';

-- ----------------------------
-- Records of wool_task
-- ----------------------------
BEGIN;
INSERT INTO `wool_task` VALUES (1, '九章头条');
INSERT INTO `wool_task` VALUES (2, '中青看点');
INSERT INTO `wool_task` VALUES (3, '腾讯自选股');
COMMIT;

-- ----------------------------
-- Table structure for wool_task_detail
-- ----------------------------
DROP TABLE IF EXISTS `wool_task_detail`;
CREATE TABLE `wool_task_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `sort` int(50) DEFAULT NULL COMMENT '每个任务排序',
  `wool_id` int(11) DEFAULT NULL COMMENT '这个任务是哪个羊毛的（关联羊毛表的id）',
  `task_name` varchar(50) DEFAULT NULL COMMENT '羊毛应用里的具体任务名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='单个羊毛';

-- ----------------------------
-- Records of wool_task_detail
-- ----------------------------
BEGIN;
INSERT INTO `wool_task_detail` VALUES (1, 1, 1, '新手任务');
INSERT INTO `wool_task_detail` VALUES (2, 2, 1, '读文章任务');
INSERT INTO `wool_task_detail` VALUES (3, 3, 1, '签到任务');
INSERT INTO `wool_task_detail` VALUES (4, 4, 1, '转发文章 5次');
INSERT INTO `wool_task_detail` VALUES (5, 5, 1, '上面四个看视频任务');
INSERT INTO `wool_task_detail` VALUES (6, 6, 1, '最顶部单独一个的看视频任务 限时福利');
INSERT INTO `wool_task_detail` VALUES (7, 7, 1, '苹果左上角签到任务');
INSERT INTO `wool_task_detail` VALUES (8, 8, 1, '苹果右上角签到后看视频任务');
INSERT INTO `wool_task_detail` VALUES (9, 9, 1, '苹果任务栏里的签到');
INSERT INTO `wool_task_detail` VALUES (10, 10, 1, '提现任务');
INSERT INTO `wool_task_detail` VALUES (11, 1, 2, '阅读文章20');
INSERT INTO `wool_task_detail` VALUES (12, 2, 2, '观看视频10');
INSERT INTO `wool_task_detail` VALUES (13, 3, 2, '火爆转发3');
INSERT INTO `wool_task_detail` VALUES (14, 4, 2, '转发文章2');
INSERT INTO `wool_task_detail` VALUES (15, 5, 2, '打卡赚钱');
INSERT INTO `wool_task_detail` VALUES (16, 6, 2, '抽奖赚钱100');
INSERT INTO `wool_task_detail` VALUES (17, 7, 2, '看福利视频5');
INSERT INTO `wool_task_detail` VALUES (18, 8, 2, '阅读5分钟5');
INSERT INTO `wool_task_detail` VALUES (19, 9, 2, '阅读60分钟60');
INSERT INTO `wool_task_detail` VALUES (20, 10, 2, '转发文章');
INSERT INTO `wool_task_detail` VALUES (21, 11, 2, '阅读推送');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
